Create Time of Day Crime Data
Step 1: Create Time of Day Crime Data (Copy and Paste chart we just created)
a. Line up the charts so they are all uniform.
b. Shared axis = Time of Day and Time by Hour, Tooltips = same but add Time by Hour
c. Sort by Time by Hour on bottom right chart
d. I am going to size the charts to be a bit bigger by hand. I am also going to change the Violent Crime Rate YOY and Major Crime Rate YOY to smaller legend names.
Check out how to create drill down in Power BI.